package com.cnvai.cms.javabean.model;

import java.math.BigDecimal;
import java.util.ArrayList;
import java.util.Date;
import java.util.Iterator;
import java.util.List;

public class YgjbxxExample {
    protected String orderByClause;

    protected boolean distinct;

    protected List<Criteria> oredCriteria;

    public YgjbxxExample() {
        oredCriteria = new ArrayList<Criteria>();
    }

    public void setOrderByClause(String orderByClause) {
        this.orderByClause = orderByClause;
    }

    public String getOrderByClause() {
        return orderByClause;
    }

    public void setDistinct(boolean distinct) {
        this.distinct = distinct;
    }

    public boolean isDistinct() {
        return distinct;
    }

    public List<Criteria> getOredCriteria() {
        return oredCriteria;
    }

    public void or(Criteria criteria) {
        oredCriteria.add(criteria);
    }

    public Criteria or() {
        Criteria criteria = createCriteriaInternal();
        oredCriteria.add(criteria);
        return criteria;
    }

    public Criteria createCriteria() {
        Criteria criteria = createCriteriaInternal();
        if (oredCriteria.size() == 0) {
            oredCriteria.add(criteria);
        }
        return criteria;
    }

    protected Criteria createCriteriaInternal() {
        Criteria criteria = new Criteria();
        return criteria;
    }

    public void clear() {
        oredCriteria.clear();
        orderByClause = null;
        distinct = false;
    }

    protected abstract static class GeneratedCriteria {
        protected List<Criterion> criteria;

        protected GeneratedCriteria() {
            super();
            criteria = new ArrayList<Criterion>();
        }

        public boolean isValid() {
            return criteria.size() > 0;
        }

        public List<Criterion> getAllCriteria() {
            return criteria;
        }

        public List<Criterion> getCriteria() {
            return criteria;
        }

        protected void addCriterion(String condition) {
            if (condition == null) {
                throw new RuntimeException("Value for condition cannot be null");
            }
            criteria.add(new Criterion(condition));
        }

        protected void addCriterion(String condition, Object value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value));
        }

        protected void addCriterion(String condition, Object value1, Object value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            criteria.add(new Criterion(condition, value1, value2));
        }

        protected void addCriterionForJDBCDate(String condition, Date value, String property) {
            if (value == null) {
                throw new RuntimeException("Value for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value.getTime()), property);
        }

        protected void addCriterionForJDBCDate(String condition, List<Date> values, String property) {
            if (values == null || values.size() == 0) {
                throw new RuntimeException("Value list for " + property + " cannot be null or empty");
            }
            List<java.sql.Date> dateList = new ArrayList<java.sql.Date>();
            Iterator<Date> iter = values.iterator();
            while (iter.hasNext()) {
                dateList.add(new java.sql.Date(iter.next().getTime()));
            }
            addCriterion(condition, dateList, property);
        }

        protected void addCriterionForJDBCDate(String condition, Date value1, Date value2, String property) {
            if (value1 == null || value2 == null) {
                throw new RuntimeException("Between values for " + property + " cannot be null");
            }
            addCriterion(condition, new java.sql.Date(value1.getTime()), new java.sql.Date(value2.getTime()), property);
        }

        public Criteria andIdIsNull() {
            addCriterion("ID is null");
            return (Criteria) this;
        }

        public Criteria andIdIsNotNull() {
            addCriterion("ID is not null");
            return (Criteria) this;
        }

        public Criteria andIdEqualTo(BigDecimal value) {
            addCriterion("ID =", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotEqualTo(BigDecimal value) {
            addCriterion("ID <>", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThan(BigDecimal value) {
            addCriterion("ID >", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ID >=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThan(BigDecimal value) {
            addCriterion("ID <", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ID <=", value, "id");
            return (Criteria) this;
        }

        public Criteria andIdIn(List<BigDecimal> values) {
            addCriterion("ID in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotIn(List<BigDecimal> values) {
            addCriterion("ID not in", values, "id");
            return (Criteria) this;
        }

        public Criteria andIdBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ID between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andIdNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ID not between", value1, value2, "id");
            return (Criteria) this;
        }

        public Criteria andYgbmIsNull() {
            addCriterion("YGBM is null");
            return (Criteria) this;
        }

        public Criteria andYgbmIsNotNull() {
            addCriterion("YGBM is not null");
            return (Criteria) this;
        }

        public Criteria andYgbmEqualTo(String value) {
            addCriterion("YGBM =", value, "ygbm");
            return (Criteria) this;
        }

        public Criteria andYgbmNotEqualTo(String value) {
            addCriterion("YGBM <>", value, "ygbm");
            return (Criteria) this;
        }

        public Criteria andYgbmGreaterThan(String value) {
            addCriterion("YGBM >", value, "ygbm");
            return (Criteria) this;
        }

        public Criteria andYgbmGreaterThanOrEqualTo(String value) {
            addCriterion("YGBM >=", value, "ygbm");
            return (Criteria) this;
        }

        public Criteria andYgbmLessThan(String value) {
            addCriterion("YGBM <", value, "ygbm");
            return (Criteria) this;
        }

        public Criteria andYgbmLessThanOrEqualTo(String value) {
            addCriterion("YGBM <=", value, "ygbm");
            return (Criteria) this;
        }

        public Criteria andYgbmLike(String value) {
            addCriterion("YGBM like", value, "ygbm");
            return (Criteria) this;
        }

        public Criteria andYgbmNotLike(String value) {
            addCriterion("YGBM not like", value, "ygbm");
            return (Criteria) this;
        }

        public Criteria andYgbmIn(List<String> values) {
            addCriterion("YGBM in", values, "ygbm");
            return (Criteria) this;
        }

        public Criteria andYgbmNotIn(List<String> values) {
            addCriterion("YGBM not in", values, "ygbm");
            return (Criteria) this;
        }

        public Criteria andYgbmBetween(String value1, String value2) {
            addCriterion("YGBM between", value1, value2, "ygbm");
            return (Criteria) this;
        }

        public Criteria andYgbmNotBetween(String value1, String value2) {
            addCriterion("YGBM not between", value1, value2, "ygbm");
            return (Criteria) this;
        }

        public Criteria andZxztIsNull() {
            addCriterion("ZXZT is null");
            return (Criteria) this;
        }

        public Criteria andZxztIsNotNull() {
            addCriterion("ZXZT is not null");
            return (Criteria) this;
        }

        public Criteria andZxztEqualTo(BigDecimal value) {
            addCriterion("ZXZT =", value, "zxzt");
            return (Criteria) this;
        }

        public Criteria andZxztNotEqualTo(BigDecimal value) {
            addCriterion("ZXZT <>", value, "zxzt");
            return (Criteria) this;
        }

        public Criteria andZxztGreaterThan(BigDecimal value) {
            addCriterion("ZXZT >", value, "zxzt");
            return (Criteria) this;
        }

        public Criteria andZxztGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("ZXZT >=", value, "zxzt");
            return (Criteria) this;
        }

        public Criteria andZxztLessThan(BigDecimal value) {
            addCriterion("ZXZT <", value, "zxzt");
            return (Criteria) this;
        }

        public Criteria andZxztLessThanOrEqualTo(BigDecimal value) {
            addCriterion("ZXZT <=", value, "zxzt");
            return (Criteria) this;
        }

        public Criteria andZxztIn(List<BigDecimal> values) {
            addCriterion("ZXZT in", values, "zxzt");
            return (Criteria) this;
        }

        public Criteria andZxztNotIn(List<BigDecimal> values) {
            addCriterion("ZXZT not in", values, "zxzt");
            return (Criteria) this;
        }

        public Criteria andZxztBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ZXZT between", value1, value2, "zxzt");
            return (Criteria) this;
        }

        public Criteria andZxztNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("ZXZT not between", value1, value2, "zxzt");
            return (Criteria) this;
        }

        public Criteria andGrxtszIsNull() {
            addCriterion("GRXTSZ is null");
            return (Criteria) this;
        }

        public Criteria andGrxtszIsNotNull() {
            addCriterion("GRXTSZ is not null");
            return (Criteria) this;
        }

        public Criteria andGrxtszEqualTo(BigDecimal value) {
            addCriterion("GRXTSZ =", value, "grxtsz");
            return (Criteria) this;
        }

        public Criteria andGrxtszNotEqualTo(BigDecimal value) {
            addCriterion("GRXTSZ <>", value, "grxtsz");
            return (Criteria) this;
        }

        public Criteria andGrxtszGreaterThan(BigDecimal value) {
            addCriterion("GRXTSZ >", value, "grxtsz");
            return (Criteria) this;
        }

        public Criteria andGrxtszGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("GRXTSZ >=", value, "grxtsz");
            return (Criteria) this;
        }

        public Criteria andGrxtszLessThan(BigDecimal value) {
            addCriterion("GRXTSZ <", value, "grxtsz");
            return (Criteria) this;
        }

        public Criteria andGrxtszLessThanOrEqualTo(BigDecimal value) {
            addCriterion("GRXTSZ <=", value, "grxtsz");
            return (Criteria) this;
        }

        public Criteria andGrxtszIn(List<BigDecimal> values) {
            addCriterion("GRXTSZ in", values, "grxtsz");
            return (Criteria) this;
        }

        public Criteria andGrxtszNotIn(List<BigDecimal> values) {
            addCriterion("GRXTSZ not in", values, "grxtsz");
            return (Criteria) this;
        }

        public Criteria andGrxtszBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("GRXTSZ between", value1, value2, "grxtsz");
            return (Criteria) this;
        }

        public Criteria andGrxtszNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("GRXTSZ not between", value1, value2, "grxtsz");
            return (Criteria) this;
        }

        public Criteria andYgmmIsNull() {
            addCriterion("YGMM is null");
            return (Criteria) this;
        }

        public Criteria andYgmmIsNotNull() {
            addCriterion("YGMM is not null");
            return (Criteria) this;
        }

        public Criteria andYgmmEqualTo(String value) {
            addCriterion("YGMM =", value, "ygmm");
            return (Criteria) this;
        }

        public Criteria andYgmmNotEqualTo(String value) {
            addCriterion("YGMM <>", value, "ygmm");
            return (Criteria) this;
        }

        public Criteria andYgmmGreaterThan(String value) {
            addCriterion("YGMM >", value, "ygmm");
            return (Criteria) this;
        }

        public Criteria andYgmmGreaterThanOrEqualTo(String value) {
            addCriterion("YGMM >=", value, "ygmm");
            return (Criteria) this;
        }

        public Criteria andYgmmLessThan(String value) {
            addCriterion("YGMM <", value, "ygmm");
            return (Criteria) this;
        }

        public Criteria andYgmmLessThanOrEqualTo(String value) {
            addCriterion("YGMM <=", value, "ygmm");
            return (Criteria) this;
        }

        public Criteria andYgmmLike(String value) {
            addCriterion("YGMM like", value, "ygmm");
            return (Criteria) this;
        }

        public Criteria andYgmmNotLike(String value) {
            addCriterion("YGMM not like", value, "ygmm");
            return (Criteria) this;
        }

        public Criteria andYgmmIn(List<String> values) {
            addCriterion("YGMM in", values, "ygmm");
            return (Criteria) this;
        }

        public Criteria andYgmmNotIn(List<String> values) {
            addCriterion("YGMM not in", values, "ygmm");
            return (Criteria) this;
        }

        public Criteria andYgmmBetween(String value1, String value2) {
            addCriterion("YGMM between", value1, value2, "ygmm");
            return (Criteria) this;
        }

        public Criteria andYgmmNotBetween(String value1, String value2) {
            addCriterion("YGMM not between", value1, value2, "ygmm");
            return (Criteria) this;
        }

        public Criteria andYgxmIsNull() {
            addCriterion("YGXM is null");
            return (Criteria) this;
        }

        public Criteria andYgxmIsNotNull() {
            addCriterion("YGXM is not null");
            return (Criteria) this;
        }

        public Criteria andYgxmEqualTo(String value) {
            addCriterion("YGXM =", value, "ygxm");
            return (Criteria) this;
        }

        public Criteria andYgxmNotEqualTo(String value) {
            addCriterion("YGXM <>", value, "ygxm");
            return (Criteria) this;
        }

        public Criteria andYgxmGreaterThan(String value) {
            addCriterion("YGXM >", value, "ygxm");
            return (Criteria) this;
        }

        public Criteria andYgxmGreaterThanOrEqualTo(String value) {
            addCriterion("YGXM >=", value, "ygxm");
            return (Criteria) this;
        }

        public Criteria andYgxmLessThan(String value) {
            addCriterion("YGXM <", value, "ygxm");
            return (Criteria) this;
        }

        public Criteria andYgxmLessThanOrEqualTo(String value) {
            addCriterion("YGXM <=", value, "ygxm");
            return (Criteria) this;
        }

        public Criteria andYgxmLike(String value) {
            addCriterion("YGXM like", value, "ygxm");
            return (Criteria) this;
        }

        public Criteria andYgxmNotLike(String value) {
            addCriterion("YGXM not like", value, "ygxm");
            return (Criteria) this;
        }

        public Criteria andYgxmIn(List<String> values) {
            addCriterion("YGXM in", values, "ygxm");
            return (Criteria) this;
        }

        public Criteria andYgxmNotIn(List<String> values) {
            addCriterion("YGXM not in", values, "ygxm");
            return (Criteria) this;
        }

        public Criteria andYgxmBetween(String value1, String value2) {
            addCriterion("YGXM between", value1, value2, "ygxm");
            return (Criteria) this;
        }

        public Criteria andYgxmNotBetween(String value1, String value2) {
            addCriterion("YGXM not between", value1, value2, "ygxm");
            return (Criteria) this;
        }

        public Criteria andSocketidIsNull() {
            addCriterion("SOCKETID is null");
            return (Criteria) this;
        }

        public Criteria andSocketidIsNotNull() {
            addCriterion("SOCKETID is not null");
            return (Criteria) this;
        }

        public Criteria andSocketidEqualTo(BigDecimal value) {
            addCriterion("SOCKETID =", value, "socketid");
            return (Criteria) this;
        }

        public Criteria andSocketidNotEqualTo(BigDecimal value) {
            addCriterion("SOCKETID <>", value, "socketid");
            return (Criteria) this;
        }

        public Criteria andSocketidGreaterThan(BigDecimal value) {
            addCriterion("SOCKETID >", value, "socketid");
            return (Criteria) this;
        }

        public Criteria andSocketidGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SOCKETID >=", value, "socketid");
            return (Criteria) this;
        }

        public Criteria andSocketidLessThan(BigDecimal value) {
            addCriterion("SOCKETID <", value, "socketid");
            return (Criteria) this;
        }

        public Criteria andSocketidLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SOCKETID <=", value, "socketid");
            return (Criteria) this;
        }

        public Criteria andSocketidIn(List<BigDecimal> values) {
            addCriterion("SOCKETID in", values, "socketid");
            return (Criteria) this;
        }

        public Criteria andSocketidNotIn(List<BigDecimal> values) {
            addCriterion("SOCKETID not in", values, "socketid");
            return (Criteria) this;
        }

        public Criteria andSocketidBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SOCKETID between", value1, value2, "socketid");
            return (Criteria) this;
        }

        public Criteria andSocketidNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SOCKETID not between", value1, value2, "socketid");
            return (Criteria) this;
        }

        public Criteria andYgxbIsNull() {
            addCriterion("YGXB is null");
            return (Criteria) this;
        }

        public Criteria andYgxbIsNotNull() {
            addCriterion("YGXB is not null");
            return (Criteria) this;
        }

        public Criteria andYgxbEqualTo(String value) {
            addCriterion("YGXB =", value, "ygxb");
            return (Criteria) this;
        }

        public Criteria andYgxbNotEqualTo(String value) {
            addCriterion("YGXB <>", value, "ygxb");
            return (Criteria) this;
        }

        public Criteria andYgxbGreaterThan(String value) {
            addCriterion("YGXB >", value, "ygxb");
            return (Criteria) this;
        }

        public Criteria andYgxbGreaterThanOrEqualTo(String value) {
            addCriterion("YGXB >=", value, "ygxb");
            return (Criteria) this;
        }

        public Criteria andYgxbLessThan(String value) {
            addCriterion("YGXB <", value, "ygxb");
            return (Criteria) this;
        }

        public Criteria andYgxbLessThanOrEqualTo(String value) {
            addCriterion("YGXB <=", value, "ygxb");
            return (Criteria) this;
        }

        public Criteria andYgxbLike(String value) {
            addCriterion("YGXB like", value, "ygxb");
            return (Criteria) this;
        }

        public Criteria andYgxbNotLike(String value) {
            addCriterion("YGXB not like", value, "ygxb");
            return (Criteria) this;
        }

        public Criteria andYgxbIn(List<String> values) {
            addCriterion("YGXB in", values, "ygxb");
            return (Criteria) this;
        }

        public Criteria andYgxbNotIn(List<String> values) {
            addCriterion("YGXB not in", values, "ygxb");
            return (Criteria) this;
        }

        public Criteria andYgxbBetween(String value1, String value2) {
            addCriterion("YGXB between", value1, value2, "ygxb");
            return (Criteria) this;
        }

        public Criteria andYgxbNotBetween(String value1, String value2) {
            addCriterion("YGXB not between", value1, value2, "ygxb");
            return (Criteria) this;
        }

        public Criteria andBlsfzhIsNull() {
            addCriterion("BLSFZH is null");
            return (Criteria) this;
        }

        public Criteria andBlsfzhIsNotNull() {
            addCriterion("BLSFZH is not null");
            return (Criteria) this;
        }

        public Criteria andBlsfzhEqualTo(String value) {
            addCriterion("BLSFZH =", value, "blsfzh");
            return (Criteria) this;
        }

        public Criteria andBlsfzhNotEqualTo(String value) {
            addCriterion("BLSFZH <>", value, "blsfzh");
            return (Criteria) this;
        }

        public Criteria andBlsfzhGreaterThan(String value) {
            addCriterion("BLSFZH >", value, "blsfzh");
            return (Criteria) this;
        }

        public Criteria andBlsfzhGreaterThanOrEqualTo(String value) {
            addCriterion("BLSFZH >=", value, "blsfzh");
            return (Criteria) this;
        }

        public Criteria andBlsfzhLessThan(String value) {
            addCriterion("BLSFZH <", value, "blsfzh");
            return (Criteria) this;
        }

        public Criteria andBlsfzhLessThanOrEqualTo(String value) {
            addCriterion("BLSFZH <=", value, "blsfzh");
            return (Criteria) this;
        }

        public Criteria andBlsfzhLike(String value) {
            addCriterion("BLSFZH like", value, "blsfzh");
            return (Criteria) this;
        }

        public Criteria andBlsfzhNotLike(String value) {
            addCriterion("BLSFZH not like", value, "blsfzh");
            return (Criteria) this;
        }

        public Criteria andBlsfzhIn(List<String> values) {
            addCriterion("BLSFZH in", values, "blsfzh");
            return (Criteria) this;
        }

        public Criteria andBlsfzhNotIn(List<String> values) {
            addCriterion("BLSFZH not in", values, "blsfzh");
            return (Criteria) this;
        }

        public Criteria andBlsfzhBetween(String value1, String value2) {
            addCriterion("BLSFZH between", value1, value2, "blsfzh");
            return (Criteria) this;
        }

        public Criteria andBlsfzhNotBetween(String value1, String value2) {
            addCriterion("BLSFZH not between", value1, value2, "blsfzh");
            return (Criteria) this;
        }

        public Criteria andGzdhIsNull() {
            addCriterion("GZDH is null");
            return (Criteria) this;
        }

        public Criteria andGzdhIsNotNull() {
            addCriterion("GZDH is not null");
            return (Criteria) this;
        }

        public Criteria andGzdhEqualTo(String value) {
            addCriterion("GZDH =", value, "gzdh");
            return (Criteria) this;
        }

        public Criteria andGzdhNotEqualTo(String value) {
            addCriterion("GZDH <>", value, "gzdh");
            return (Criteria) this;
        }

        public Criteria andGzdhGreaterThan(String value) {
            addCriterion("GZDH >", value, "gzdh");
            return (Criteria) this;
        }

        public Criteria andGzdhGreaterThanOrEqualTo(String value) {
            addCriterion("GZDH >=", value, "gzdh");
            return (Criteria) this;
        }

        public Criteria andGzdhLessThan(String value) {
            addCriterion("GZDH <", value, "gzdh");
            return (Criteria) this;
        }

        public Criteria andGzdhLessThanOrEqualTo(String value) {
            addCriterion("GZDH <=", value, "gzdh");
            return (Criteria) this;
        }

        public Criteria andGzdhLike(String value) {
            addCriterion("GZDH like", value, "gzdh");
            return (Criteria) this;
        }

        public Criteria andGzdhNotLike(String value) {
            addCriterion("GZDH not like", value, "gzdh");
            return (Criteria) this;
        }

        public Criteria andGzdhIn(List<String> values) {
            addCriterion("GZDH in", values, "gzdh");
            return (Criteria) this;
        }

        public Criteria andGzdhNotIn(List<String> values) {
            addCriterion("GZDH not in", values, "gzdh");
            return (Criteria) this;
        }

        public Criteria andGzdhBetween(String value1, String value2) {
            addCriterion("GZDH between", value1, value2, "gzdh");
            return (Criteria) this;
        }

        public Criteria andGzdhNotBetween(String value1, String value2) {
            addCriterion("GZDH not between", value1, value2, "gzdh");
            return (Criteria) this;
        }

        public Criteria andYddhIsNull() {
            addCriterion("YDDH is null");
            return (Criteria) this;
        }

        public Criteria andYddhIsNotNull() {
            addCriterion("YDDH is not null");
            return (Criteria) this;
        }

        public Criteria andYddhEqualTo(String value) {
            addCriterion("YDDH =", value, "yddh");
            return (Criteria) this;
        }

        public Criteria andYddhNotEqualTo(String value) {
            addCriterion("YDDH <>", value, "yddh");
            return (Criteria) this;
        }

        public Criteria andYddhGreaterThan(String value) {
            addCriterion("YDDH >", value, "yddh");
            return (Criteria) this;
        }

        public Criteria andYddhGreaterThanOrEqualTo(String value) {
            addCriterion("YDDH >=", value, "yddh");
            return (Criteria) this;
        }

        public Criteria andYddhLessThan(String value) {
            addCriterion("YDDH <", value, "yddh");
            return (Criteria) this;
        }

        public Criteria andYddhLessThanOrEqualTo(String value) {
            addCriterion("YDDH <=", value, "yddh");
            return (Criteria) this;
        }

        public Criteria andYddhLike(String value) {
            addCriterion("YDDH like", value, "yddh");
            return (Criteria) this;
        }

        public Criteria andYddhNotLike(String value) {
            addCriterion("YDDH not like", value, "yddh");
            return (Criteria) this;
        }

        public Criteria andYddhIn(List<String> values) {
            addCriterion("YDDH in", values, "yddh");
            return (Criteria) this;
        }

        public Criteria andYddhNotIn(List<String> values) {
            addCriterion("YDDH not in", values, "yddh");
            return (Criteria) this;
        }

        public Criteria andYddhBetween(String value1, String value2) {
            addCriterion("YDDH between", value1, value2, "yddh");
            return (Criteria) this;
        }

        public Criteria andYddhNotBetween(String value1, String value2) {
            addCriterion("YDDH not between", value1, value2, "yddh");
            return (Criteria) this;
        }

        public Criteria andYggxqmIsNull() {
            addCriterion("YGGXQM is null");
            return (Criteria) this;
        }

        public Criteria andYggxqmIsNotNull() {
            addCriterion("YGGXQM is not null");
            return (Criteria) this;
        }

        public Criteria andYggxqmEqualTo(String value) {
            addCriterion("YGGXQM =", value, "yggxqm");
            return (Criteria) this;
        }

        public Criteria andYggxqmNotEqualTo(String value) {
            addCriterion("YGGXQM <>", value, "yggxqm");
            return (Criteria) this;
        }

        public Criteria andYggxqmGreaterThan(String value) {
            addCriterion("YGGXQM >", value, "yggxqm");
            return (Criteria) this;
        }

        public Criteria andYggxqmGreaterThanOrEqualTo(String value) {
            addCriterion("YGGXQM >=", value, "yggxqm");
            return (Criteria) this;
        }

        public Criteria andYggxqmLessThan(String value) {
            addCriterion("YGGXQM <", value, "yggxqm");
            return (Criteria) this;
        }

        public Criteria andYggxqmLessThanOrEqualTo(String value) {
            addCriterion("YGGXQM <=", value, "yggxqm");
            return (Criteria) this;
        }

        public Criteria andYggxqmLike(String value) {
            addCriterion("YGGXQM like", value, "yggxqm");
            return (Criteria) this;
        }

        public Criteria andYggxqmNotLike(String value) {
            addCriterion("YGGXQM not like", value, "yggxqm");
            return (Criteria) this;
        }

        public Criteria andYggxqmIn(List<String> values) {
            addCriterion("YGGXQM in", values, "yggxqm");
            return (Criteria) this;
        }

        public Criteria andYggxqmNotIn(List<String> values) {
            addCriterion("YGGXQM not in", values, "yggxqm");
            return (Criteria) this;
        }

        public Criteria andYggxqmBetween(String value1, String value2) {
            addCriterion("YGGXQM between", value1, value2, "yggxqm");
            return (Criteria) this;
        }

        public Criteria andYggxqmNotBetween(String value1, String value2) {
            addCriterion("YGGXQM not between", value1, value2, "yggxqm");
            return (Criteria) this;
        }

        public Criteria andDzyjIsNull() {
            addCriterion("DZYJ is null");
            return (Criteria) this;
        }

        public Criteria andDzyjIsNotNull() {
            addCriterion("DZYJ is not null");
            return (Criteria) this;
        }

        public Criteria andDzyjEqualTo(String value) {
            addCriterion("DZYJ =", value, "dzyj");
            return (Criteria) this;
        }

        public Criteria andDzyjNotEqualTo(String value) {
            addCriterion("DZYJ <>", value, "dzyj");
            return (Criteria) this;
        }

        public Criteria andDzyjGreaterThan(String value) {
            addCriterion("DZYJ >", value, "dzyj");
            return (Criteria) this;
        }

        public Criteria andDzyjGreaterThanOrEqualTo(String value) {
            addCriterion("DZYJ >=", value, "dzyj");
            return (Criteria) this;
        }

        public Criteria andDzyjLessThan(String value) {
            addCriterion("DZYJ <", value, "dzyj");
            return (Criteria) this;
        }

        public Criteria andDzyjLessThanOrEqualTo(String value) {
            addCriterion("DZYJ <=", value, "dzyj");
            return (Criteria) this;
        }

        public Criteria andDzyjLike(String value) {
            addCriterion("DZYJ like", value, "dzyj");
            return (Criteria) this;
        }

        public Criteria andDzyjNotLike(String value) {
            addCriterion("DZYJ not like", value, "dzyj");
            return (Criteria) this;
        }

        public Criteria andDzyjIn(List<String> values) {
            addCriterion("DZYJ in", values, "dzyj");
            return (Criteria) this;
        }

        public Criteria andDzyjNotIn(List<String> values) {
            addCriterion("DZYJ not in", values, "dzyj");
            return (Criteria) this;
        }

        public Criteria andDzyjBetween(String value1, String value2) {
            addCriterion("DZYJ between", value1, value2, "dzyj");
            return (Criteria) this;
        }

        public Criteria andDzyjNotBetween(String value1, String value2) {
            addCriterion("DZYJ not between", value1, value2, "dzyj");
            return (Criteria) this;
        }

        public Criteria andCsrqIsNull() {
            addCriterion("CSRQ is null");
            return (Criteria) this;
        }

        public Criteria andCsrqIsNotNull() {
            addCriterion("CSRQ is not null");
            return (Criteria) this;
        }

        public Criteria andCsrqEqualTo(Date value) {
            addCriterionForJDBCDate("CSRQ =", value, "csrq");
            return (Criteria) this;
        }

        public Criteria andCsrqNotEqualTo(Date value) {
            addCriterionForJDBCDate("CSRQ <>", value, "csrq");
            return (Criteria) this;
        }

        public Criteria andCsrqGreaterThan(Date value) {
            addCriterionForJDBCDate("CSRQ >", value, "csrq");
            return (Criteria) this;
        }

        public Criteria andCsrqGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("CSRQ >=", value, "csrq");
            return (Criteria) this;
        }

        public Criteria andCsrqLessThan(Date value) {
            addCriterionForJDBCDate("CSRQ <", value, "csrq");
            return (Criteria) this;
        }

        public Criteria andCsrqLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("CSRQ <=", value, "csrq");
            return (Criteria) this;
        }

        public Criteria andCsrqIn(List<Date> values) {
            addCriterionForJDBCDate("CSRQ in", values, "csrq");
            return (Criteria) this;
        }

        public Criteria andCsrqNotIn(List<Date> values) {
            addCriterionForJDBCDate("CSRQ not in", values, "csrq");
            return (Criteria) this;
        }

        public Criteria andCsrqBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("CSRQ between", value1, value2, "csrq");
            return (Criteria) this;
        }

        public Criteria andCsrqNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("CSRQ not between", value1, value2, "csrq");
            return (Criteria) this;
        }

        public Criteria andXlIsNull() {
            addCriterion("XL is null");
            return (Criteria) this;
        }

        public Criteria andXlIsNotNull() {
            addCriterion("XL is not null");
            return (Criteria) this;
        }

        public Criteria andXlEqualTo(String value) {
            addCriterion("XL =", value, "xl");
            return (Criteria) this;
        }

        public Criteria andXlNotEqualTo(String value) {
            addCriterion("XL <>", value, "xl");
            return (Criteria) this;
        }

        public Criteria andXlGreaterThan(String value) {
            addCriterion("XL >", value, "xl");
            return (Criteria) this;
        }

        public Criteria andXlGreaterThanOrEqualTo(String value) {
            addCriterion("XL >=", value, "xl");
            return (Criteria) this;
        }

        public Criteria andXlLessThan(String value) {
            addCriterion("XL <", value, "xl");
            return (Criteria) this;
        }

        public Criteria andXlLessThanOrEqualTo(String value) {
            addCriterion("XL <=", value, "xl");
            return (Criteria) this;
        }

        public Criteria andXlLike(String value) {
            addCriterion("XL like", value, "xl");
            return (Criteria) this;
        }

        public Criteria andXlNotLike(String value) {
            addCriterion("XL not like", value, "xl");
            return (Criteria) this;
        }

        public Criteria andXlIn(List<String> values) {
            addCriterion("XL in", values, "xl");
            return (Criteria) this;
        }

        public Criteria andXlNotIn(List<String> values) {
            addCriterion("XL not in", values, "xl");
            return (Criteria) this;
        }

        public Criteria andXlBetween(String value1, String value2) {
            addCriterion("XL between", value1, value2, "xl");
            return (Criteria) this;
        }

        public Criteria andXlNotBetween(String value1, String value2) {
            addCriterion("XL not between", value1, value2, "xl");
            return (Criteria) this;
        }

        public Criteria andByyxIsNull() {
            addCriterion("BYYX is null");
            return (Criteria) this;
        }

        public Criteria andByyxIsNotNull() {
            addCriterion("BYYX is not null");
            return (Criteria) this;
        }

        public Criteria andByyxEqualTo(String value) {
            addCriterion("BYYX =", value, "byyx");
            return (Criteria) this;
        }

        public Criteria andByyxNotEqualTo(String value) {
            addCriterion("BYYX <>", value, "byyx");
            return (Criteria) this;
        }

        public Criteria andByyxGreaterThan(String value) {
            addCriterion("BYYX >", value, "byyx");
            return (Criteria) this;
        }

        public Criteria andByyxGreaterThanOrEqualTo(String value) {
            addCriterion("BYYX >=", value, "byyx");
            return (Criteria) this;
        }

        public Criteria andByyxLessThan(String value) {
            addCriterion("BYYX <", value, "byyx");
            return (Criteria) this;
        }

        public Criteria andByyxLessThanOrEqualTo(String value) {
            addCriterion("BYYX <=", value, "byyx");
            return (Criteria) this;
        }

        public Criteria andByyxLike(String value) {
            addCriterion("BYYX like", value, "byyx");
            return (Criteria) this;
        }

        public Criteria andByyxNotLike(String value) {
            addCriterion("BYYX not like", value, "byyx");
            return (Criteria) this;
        }

        public Criteria andByyxIn(List<String> values) {
            addCriterion("BYYX in", values, "byyx");
            return (Criteria) this;
        }

        public Criteria andByyxNotIn(List<String> values) {
            addCriterion("BYYX not in", values, "byyx");
            return (Criteria) this;
        }

        public Criteria andByyxBetween(String value1, String value2) {
            addCriterion("BYYX between", value1, value2, "byyx");
            return (Criteria) this;
        }

        public Criteria andByyxNotBetween(String value1, String value2) {
            addCriterion("BYYX not between", value1, value2, "byyx");
            return (Criteria) this;
        }

        public Criteria andZyIsNull() {
            addCriterion("ZY is null");
            return (Criteria) this;
        }

        public Criteria andZyIsNotNull() {
            addCriterion("ZY is not null");
            return (Criteria) this;
        }

        public Criteria andZyEqualTo(String value) {
            addCriterion("ZY =", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyNotEqualTo(String value) {
            addCriterion("ZY <>", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyGreaterThan(String value) {
            addCriterion("ZY >", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyGreaterThanOrEqualTo(String value) {
            addCriterion("ZY >=", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyLessThan(String value) {
            addCriterion("ZY <", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyLessThanOrEqualTo(String value) {
            addCriterion("ZY <=", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyLike(String value) {
            addCriterion("ZY like", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyNotLike(String value) {
            addCriterion("ZY not like", value, "zy");
            return (Criteria) this;
        }

        public Criteria andZyIn(List<String> values) {
            addCriterion("ZY in", values, "zy");
            return (Criteria) this;
        }

        public Criteria andZyNotIn(List<String> values) {
            addCriterion("ZY not in", values, "zy");
            return (Criteria) this;
        }

        public Criteria andZyBetween(String value1, String value2) {
            addCriterion("ZY between", value1, value2, "zy");
            return (Criteria) this;
        }

        public Criteria andZyNotBetween(String value1, String value2) {
            addCriterion("ZY not between", value1, value2, "zy");
            return (Criteria) this;
        }

        public Criteria andSfyfsyjfwIsNull() {
            addCriterion("SFYFSYJFW is null");
            return (Criteria) this;
        }

        public Criteria andSfyfsyjfwIsNotNull() {
            addCriterion("SFYFSYJFW is not null");
            return (Criteria) this;
        }

        public Criteria andSfyfsyjfwEqualTo(BigDecimal value) {
            addCriterion("SFYFSYJFW =", value, "sfyfsyjfw");
            return (Criteria) this;
        }

        public Criteria andSfyfsyjfwNotEqualTo(BigDecimal value) {
            addCriterion("SFYFSYJFW <>", value, "sfyfsyjfw");
            return (Criteria) this;
        }

        public Criteria andSfyfsyjfwGreaterThan(BigDecimal value) {
            addCriterion("SFYFSYJFW >", value, "sfyfsyjfw");
            return (Criteria) this;
        }

        public Criteria andSfyfsyjfwGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SFYFSYJFW >=", value, "sfyfsyjfw");
            return (Criteria) this;
        }

        public Criteria andSfyfsyjfwLessThan(BigDecimal value) {
            addCriterion("SFYFSYJFW <", value, "sfyfsyjfw");
            return (Criteria) this;
        }

        public Criteria andSfyfsyjfwLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SFYFSYJFW <=", value, "sfyfsyjfw");
            return (Criteria) this;
        }

        public Criteria andSfyfsyjfwIn(List<BigDecimal> values) {
            addCriterion("SFYFSYJFW in", values, "sfyfsyjfw");
            return (Criteria) this;
        }

        public Criteria andSfyfsyjfwNotIn(List<BigDecimal> values) {
            addCriterion("SFYFSYJFW not in", values, "sfyfsyjfw");
            return (Criteria) this;
        }

        public Criteria andSfyfsyjfwBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SFYFSYJFW between", value1, value2, "sfyfsyjfw");
            return (Criteria) this;
        }

        public Criteria andSfyfsyjfwNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SFYFSYJFW not between", value1, value2, "sfyfsyjfw");
            return (Criteria) this;
        }

        public Criteria andLogoggsjIsNull() {
            addCriterion("LOGOGGSJ is null");
            return (Criteria) this;
        }

        public Criteria andLogoggsjIsNotNull() {
            addCriterion("LOGOGGSJ is not null");
            return (Criteria) this;
        }

        public Criteria andLogoggsjEqualTo(Date value) {
            addCriterionForJDBCDate("LOGOGGSJ =", value, "logoggsj");
            return (Criteria) this;
        }

        public Criteria andLogoggsjNotEqualTo(Date value) {
            addCriterionForJDBCDate("LOGOGGSJ <>", value, "logoggsj");
            return (Criteria) this;
        }

        public Criteria andLogoggsjGreaterThan(Date value) {
            addCriterionForJDBCDate("LOGOGGSJ >", value, "logoggsj");
            return (Criteria) this;
        }

        public Criteria andLogoggsjGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("LOGOGGSJ >=", value, "logoggsj");
            return (Criteria) this;
        }

        public Criteria andLogoggsjLessThan(Date value) {
            addCriterionForJDBCDate("LOGOGGSJ <", value, "logoggsj");
            return (Criteria) this;
        }

        public Criteria andLogoggsjLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("LOGOGGSJ <=", value, "logoggsj");
            return (Criteria) this;
        }

        public Criteria andLogoggsjIn(List<Date> values) {
            addCriterionForJDBCDate("LOGOGGSJ in", values, "logoggsj");
            return (Criteria) this;
        }

        public Criteria andLogoggsjNotIn(List<Date> values) {
            addCriterionForJDBCDate("LOGOGGSJ not in", values, "logoggsj");
            return (Criteria) this;
        }

        public Criteria andLogoggsjBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("LOGOGGSJ between", value1, value2, "logoggsj");
            return (Criteria) this;
        }

        public Criteria andLogoggsjNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("LOGOGGSJ not between", value1, value2, "logoggsj");
            return (Criteria) this;
        }

        public Criteria andWbxxggsjIsNull() {
            addCriterion("WBXXGGSJ is null");
            return (Criteria) this;
        }

        public Criteria andWbxxggsjIsNotNull() {
            addCriterion("WBXXGGSJ is not null");
            return (Criteria) this;
        }

        public Criteria andWbxxggsjEqualTo(Date value) {
            addCriterionForJDBCDate("WBXXGGSJ =", value, "wbxxggsj");
            return (Criteria) this;
        }

        public Criteria andWbxxggsjNotEqualTo(Date value) {
            addCriterionForJDBCDate("WBXXGGSJ <>", value, "wbxxggsj");
            return (Criteria) this;
        }

        public Criteria andWbxxggsjGreaterThan(Date value) {
            addCriterionForJDBCDate("WBXXGGSJ >", value, "wbxxggsj");
            return (Criteria) this;
        }

        public Criteria andWbxxggsjGreaterThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("WBXXGGSJ >=", value, "wbxxggsj");
            return (Criteria) this;
        }

        public Criteria andWbxxggsjLessThan(Date value) {
            addCriterionForJDBCDate("WBXXGGSJ <", value, "wbxxggsj");
            return (Criteria) this;
        }

        public Criteria andWbxxggsjLessThanOrEqualTo(Date value) {
            addCriterionForJDBCDate("WBXXGGSJ <=", value, "wbxxggsj");
            return (Criteria) this;
        }

        public Criteria andWbxxggsjIn(List<Date> values) {
            addCriterionForJDBCDate("WBXXGGSJ in", values, "wbxxggsj");
            return (Criteria) this;
        }

        public Criteria andWbxxggsjNotIn(List<Date> values) {
            addCriterionForJDBCDate("WBXXGGSJ not in", values, "wbxxggsj");
            return (Criteria) this;
        }

        public Criteria andWbxxggsjBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("WBXXGGSJ between", value1, value2, "wbxxggsj");
            return (Criteria) this;
        }

        public Criteria andWbxxggsjNotBetween(Date value1, Date value2) {
            addCriterionForJDBCDate("WBXXGGSJ not between", value1, value2, "wbxxggsj");
            return (Criteria) this;
        }

        public Criteria andSzkzsidIsNull() {
            addCriterion("SZKZSID is null");
            return (Criteria) this;
        }

        public Criteria andSzkzsidIsNotNull() {
            addCriterion("SZKZSID is not null");
            return (Criteria) this;
        }

        public Criteria andSzkzsidEqualTo(BigDecimal value) {
            addCriterion("SZKZSID =", value, "szkzsid");
            return (Criteria) this;
        }

        public Criteria andSzkzsidNotEqualTo(BigDecimal value) {
            addCriterion("SZKZSID <>", value, "szkzsid");
            return (Criteria) this;
        }

        public Criteria andSzkzsidGreaterThan(BigDecimal value) {
            addCriterion("SZKZSID >", value, "szkzsid");
            return (Criteria) this;
        }

        public Criteria andSzkzsidGreaterThanOrEqualTo(BigDecimal value) {
            addCriterion("SZKZSID >=", value, "szkzsid");
            return (Criteria) this;
        }

        public Criteria andSzkzsidLessThan(BigDecimal value) {
            addCriterion("SZKZSID <", value, "szkzsid");
            return (Criteria) this;
        }

        public Criteria andSzkzsidLessThanOrEqualTo(BigDecimal value) {
            addCriterion("SZKZSID <=", value, "szkzsid");
            return (Criteria) this;
        }

        public Criteria andSzkzsidIn(List<BigDecimal> values) {
            addCriterion("SZKZSID in", values, "szkzsid");
            return (Criteria) this;
        }

        public Criteria andSzkzsidNotIn(List<BigDecimal> values) {
            addCriterion("SZKZSID not in", values, "szkzsid");
            return (Criteria) this;
        }

        public Criteria andSzkzsidBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SZKZSID between", value1, value2, "szkzsid");
            return (Criteria) this;
        }

        public Criteria andSzkzsidNotBetween(BigDecimal value1, BigDecimal value2) {
            addCriterion("SZKZSID not between", value1, value2, "szkzsid");
            return (Criteria) this;
        }

        public Criteria andSfyzhyIsNull() {
            addCriterion("SFYZHY is null");
            return (Criteria) this;
        }

        public Criteria andSfyzhyIsNotNull() {
            addCriterion("SFYZHY is not null");
            return (Criteria) this;
        }

        public Criteria andSfyzhyEqualTo(String value) {
            addCriterion("SFYZHY =", value, "sfyzhy");
            return (Criteria) this;
        }

        public Criteria andSfyzhyNotEqualTo(String value) {
            addCriterion("SFYZHY <>", value, "sfyzhy");
            return (Criteria) this;
        }

        public Criteria andSfyzhyGreaterThan(String value) {
            addCriterion("SFYZHY >", value, "sfyzhy");
            return (Criteria) this;
        }

        public Criteria andSfyzhyGreaterThanOrEqualTo(String value) {
            addCriterion("SFYZHY >=", value, "sfyzhy");
            return (Criteria) this;
        }

        public Criteria andSfyzhyLessThan(String value) {
            addCriterion("SFYZHY <", value, "sfyzhy");
            return (Criteria) this;
        }

        public Criteria andSfyzhyLessThanOrEqualTo(String value) {
            addCriterion("SFYZHY <=", value, "sfyzhy");
            return (Criteria) this;
        }

        public Criteria andSfyzhyLike(String value) {
            addCriterion("SFYZHY like", value, "sfyzhy");
            return (Criteria) this;
        }

        public Criteria andSfyzhyNotLike(String value) {
            addCriterion("SFYZHY not like", value, "sfyzhy");
            return (Criteria) this;
        }

        public Criteria andSfyzhyIn(List<String> values) {
            addCriterion("SFYZHY in", values, "sfyzhy");
            return (Criteria) this;
        }

        public Criteria andSfyzhyNotIn(List<String> values) {
            addCriterion("SFYZHY not in", values, "sfyzhy");
            return (Criteria) this;
        }

        public Criteria andSfyzhyBetween(String value1, String value2) {
            addCriterion("SFYZHY between", value1, value2, "sfyzhy");
            return (Criteria) this;
        }

        public Criteria andSfyzhyNotBetween(String value1, String value2) {
            addCriterion("SFYZHY not between", value1, value2, "sfyzhy");
            return (Criteria) this;
        }
    }

    public static class Criteria extends GeneratedCriteria {

        protected Criteria() {
            super();
        }
    }

    public static class Criterion {
        private String condition;

        private Object value;

        private Object secondValue;

        private boolean noValue;

        private boolean singleValue;

        private boolean betweenValue;

        private boolean listValue;

        private String typeHandler;

        public String getCondition() {
            return condition;
        }

        public Object getValue() {
            return value;
        }

        public Object getSecondValue() {
            return secondValue;
        }

        public boolean isNoValue() {
            return noValue;
        }

        public boolean isSingleValue() {
            return singleValue;
        }

        public boolean isBetweenValue() {
            return betweenValue;
        }

        public boolean isListValue() {
            return listValue;
        }

        public String getTypeHandler() {
            return typeHandler;
        }

        protected Criterion(String condition) {
            super();
            this.condition = condition;
            this.typeHandler = null;
            this.noValue = true;
        }

        protected Criterion(String condition, Object value, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.typeHandler = typeHandler;
            if (value instanceof List<?>) {
                this.listValue = true;
            } else {
                this.singleValue = true;
            }
        }

        protected Criterion(String condition, Object value) {
            this(condition, value, null);
        }

        protected Criterion(String condition, Object value, Object secondValue, String typeHandler) {
            super();
            this.condition = condition;
            this.value = value;
            this.secondValue = secondValue;
            this.typeHandler = typeHandler;
            this.betweenValue = true;
        }

        protected Criterion(String condition, Object value, Object secondValue) {
            this(condition, value, secondValue, null);
        }
    }
}